Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Department, Title, Culture, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Suffix, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object End Date, Medium, Credit Line, Geography Type, City, Country, Classification
Link | rowid ▼ | Object Number | Is Highlight | Is Public Domain | Object ID | Department | Object Name | Title | Culture | Period | Dynasty | Reign | Portfolio | Artist Role | Artist Prefix | Artist Display Name | Artist Display Bio | Artist Suffix | Artist Alpha Sort | Artist Nationality | Artist Begin Date | Artist End Date | Object Date | Object Begin Date | Object End Date | Medium | Dimensions | Credit Line | Geography Type | City | State | County | Country | Region | Subregion | Locale | Locus | Excavation | River | Classification | Rights and Reproduction | Link Resource | Metadata Date | Repository |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2010 | 2010 | 30.120.355 | 0 | 0 | 2185 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | 1850–1900 | 1850 | 1900 | Free-blown blue glass 557 | Diam. 8 in. (20.3 cm) | The Sylmaris Collection, Gift of George Coe Graves, 1930 | Possibly made in 5 | Saratoga 123 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2185 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
2011 | 2011 | 40.151 | 0 | 1 | 2186 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | 1815–35 | 1815 | 1815 | Blown-molded glass 195 | H. 3 3/8 in. (8.6 cm); Diam. 6 1/4 in. (15.9 cm) | Rogers Fund, 1940 | Probably made in 2 | Zanesville 57 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2186 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
2012 | 2012 | 46.140.1 | 0 | 1 | 2187 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | 1850–60 | 1850 | 1860 | Pressed glass 5 | H. 8 1/2 in. (21.6 cm); Diam. 11 7/8 in. (30.2 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Probably made in 2 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2187 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
2013 | 2013 | 46.140.2 | 0 | 1 | 2188 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | 1850–70 | 1850 | 1870 | Pressed glass 5 | H. 8 7/8 in. (22.5 cm); Diam. 11 1/4 in. (28.6 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Probably made in 2 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2188 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
2014 | 2014 | 46.140.4 | 0 | 1 | 2189 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | 1850–70 | 1850 | 1870 | Pressed glass 5 | H. 6 1/4 in. (15.9 cm); Diam. 7 1/2 in. (19.1 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Probably made in 2 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2189 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
2015 | 2015 | 46.140.781 | 0 | 1 | 2190 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | 1850–60 | 1850 | 1860 | Pressed glass, diamond thumbprint 178 | H. 2 1/2 in. (6.4 cm); Diam. 8 1/8 in. (20.6 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Probably made in 2 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2190 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
2016 | 2016 | 51.171.6 | 0 | 0 | 2191 | American Decorative Arts 1 | Compote 260 | Compote | 19th century | 1800 | 1900 | Lacy pressed glass 218 | H. 3 3/8 in. (8.6 cm); Diam. 5 in. (12.7 cm) | Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951 | Glass 3 | http://www.metmuseum.org/art/collection/search/2191 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
2017 | 2017 | 51.171.10 | 0 | 0 | 2192 | American Decorative Arts 1 | Compote 260 | Compote | 19th century | 1800 | 1900 | Lacy pressed glass 218 | H. 3 5/8 in. (9.2 cm); Diam. 5 in. (12.7 cm) | Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951 | Glass 3 | http://www.metmuseum.org/art/collection/search/2192 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
2018 | 2018 | 51.171.11 | 0 | 1 | 2193 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | 1830–35 | 1830 | 1835 | Lacy pressed glass 218 | H. 2 5/8 in. (6.7 cm); Diam. 6 1/8 in. (15.6 cm) | Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951 | Made in 1 | United States 3 | New England 1 | Glass 3 | http://www.metmuseum.org/art/collection/search/2193 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
2019 | 2019 | 51.171.12 | 0 | 1 | 2194 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | 1830–35 | 1830 | 1835 | Lacy pressed glass 218 | 3 3/4 x 5 1/4 in. (9.5 x 13.3 cm) | Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951 | Made in 1 | United States 3 | New England 1 | Glass 3 | http://www.metmuseum.org/art/collection/search/2194 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
2020 | 2020 | 51.171.13 | 0 | 0 | 2195 | American Decorative Arts 1 | Compote 260 | Compote | 19th century | 1800 | 1900 | Lacy pressed glass 218 | H. 6 1/16 in. (15.4 cm); Diam. 8 7/8 in. (22.5 cm) | Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951 | Glass 3 | http://www.metmuseum.org/art/collection/search/2195 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
2021 | 2021 | 51.171.14 | 0 | 0 | 2196 | American Decorative Arts 1 | Compote 260 | Compote | 19th century | 1800 | 1900 | Lacy pressed glass 218 | H. 4 5/16 in. (11 cm); Diam. 8 in. (20.3 cm) | Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951 | Glass 3 | http://www.metmuseum.org/art/collection/search/2196 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
2022 | 2022 | 51.171.15 | 0 | 0 | 2197 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | ca. 1835 | 1832 | 1835 | Lacy pressed glass 218 | 5 5/16 x 10 13/16 x 8 3/4 in. (13.5 x 27.5 x 22.2 cm) | Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951 | Probably made in 2 | United States 3 | New England 1 | Glass 3 | http://www.metmuseum.org/art/collection/search/2197 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
2023 | 2023 | 51.171.16 | 0 | 0 | 2198 | American Decorative Arts 1 | Compote 260 | Compote | 19th century | 1800 | 1900 | Lacy pressed glass 218 | H. 6 1/16 in. (15.4 cm); Diam. 10 1/2 in. (26.7 cm) | Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951 | Glass 3 | http://www.metmuseum.org/art/collection/search/2198 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
2024 | 2024 | 51.171.17 | 0 | 0 | 2199 | American Decorative Arts 1 | Compote 260 | Compote | 19th century | 1800 | 1900 | Lacy pressed glass 218 | H. 6 1/2 in. (16.5 cm); Diam. 9 7/8 in. (25.1 cm) | Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951 | Glass 3 | http://www.metmuseum.org/art/collection/search/2199 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
2025 | 2025 | 51.171.33 | 0 | 0 | 2200 | American Decorative Arts 1 | Compote 260 | Compote | 19th century | 1800 | 1900 | Lacy pressed glass 218 | H. 5 in. (12.7 cm); Diam. 8 1/2 in. (21.6 cm) | Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951 | Glass 3 | http://www.metmuseum.org/art/collection/search/2200 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
2026 | 2026 | 51.171.34 | 0 | 1 | 2201 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | ca. 1835 | 1832 | 1835 | Lacy pressed glass 218 | H. 5 1/2 in. (14 cm); Diam. 7 in. (17.8 cm) | Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951 | Made in 1 | United States 3 | New England 1 | Glass 3 | http://www.metmuseum.org/art/collection/search/2201 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
2027 | 2027 | 57.131.15 | 0 | 0 | 2202 | American Decorative Arts 1 | Compote 260 | Compote | 19th century | 1800 | 1900 | Lacy pressed glass 218 | 6 3/16 x 10 5/8 x 8 15/16 in. (15.7 x 27 x 22.7 cm) | Bequest of Anna G. W. Green, in memory of her husband, Dr. Charles W. Green, 1957 | Glass 3 | http://www.metmuseum.org/art/collection/search/2202 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||||||
2028 | 2028 | 66.154.3 | 0 | 1 | 2203 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | ca. 1840 | 1837 | 1840 | Blown lead glass 381 | H. 8 3/4 in. (22.2 cm); Diam. 9 5/16 in. (23.7 cm) | Bequest of Mrs. Richard Bogart, 1936 | Made in 1 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2203 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
2029 | 2029 | 67.262.4 | 0 | 1 | 2204 | American Decorative Arts 1 | Compote 260 | Compote | Manufacturer 20 | Attributed to | Joseph Stouvenal and Company | 1851–57 | Joseph Stouvenal and Company 356 | 1851 | 1857 | 1853 | 1853 | 1853 | Blown and cut glass 219 | H. 13 in. (33 cm); Diam. 14 in. (35.6 cm) | Gift of John C. Cattus, 1967 | Made in 1 | New York 3 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2204 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2031 | 2031 | 1980.502.10 | 0 | 1 | 2206 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Manufacturer|Manufacturer 19 | Possibly by|Possibly by | Redford Crown Glass Works|Redwood Glass Company | 1831–1851|1828–1868 | Redford Crown Glass Works|Redwood Glass Company 152 | 1831 |1828 | 1831 |1868 | 1835–65 | 1835 | 1865 | Blown glass with applied decoration 112 | H. 3 3/4 in. (9.5 cm) | Gift of Henry G. Schiff, 1980 | Made in 1 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2206 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2032 | 2032 | 1983.63.2 | 0 | 1 | 2207 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker|Maker 6 | Benjamin Bakewell & Co.|Bakewell, Page & Bakewell | 1809–1813|1808–1882 | or | Benjamin Bakewell & Co.|Bakewell, Page & Bakewell 266 | 1809 |1808 | 1813 |1882 | 1810–25 | 1810 | 1825 | Blown-molded and engraved glass 380 | H. 5 3/4 in. (14.6 cm); Diam. 8 13/16 in. (22.4 cm) | Purchase, M. B. and Fannie Finkelstein Foundation Gift, 1983 | Probably made in 2 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2207 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
2033 | 2033 | 57.131.14 | 0 | 1 | 2208 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Possibly | Boston & Sandwich Glass Company | American, 1825–1888, Sandwich, Massachusetts | Boston and Sandwich Glass Company 62 | 1825 | 1888 | 1830–50 | 1830 | 1850 | Lacy pressed glass 218 | 6 1/16 x 10 5/8 x 8 15/16 in. (15.4 x 27 x 22.7 cm) | Bequest of Anna G. W. Green, in memory of her husband, Dr. Charles W. Green, 1957 | Probably made in 2 | Sandwich 31 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2208 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
2034 | 2034 | 69.257 | 0 | 1 | 2209 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Attributed to | Christian Dorflinger | 1828–1915 | Dorflinger, Christian 232 | French 2 | 1828 | 1915 | 1855–60 | 1855 | 1860 | Cut and engraved glass 558 | H. 9 11/16 in. (24.6 cm); Diam. 10 1/4 in. (26 cm) | Gift of Stuart P. Feld, 1969 | Made in 1 | New York 3 | Brooklyn 17 | Brooklyn 17 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2209 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||
2035 | 2035 | 1972.232.1 | 0 | 1 | 2211 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Artist 2 | Long Island Flint Glass Works of Christian Dorflinger | 1852–63 | Dorflinger Christian, Long Island Flint Glass Works of 357 | 1852 | 1863 | 1861 | 1861 | 1861 | Blown, cut, and engraved glass 268 | H. 7 1/2 in. (19.1 cm) | Gift of Katheryn Hait Dorflinger Manchee, 1972 | Made in 1 | Brooklyn 48 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2211 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2036 | 2036 | 48.135.3 | 0 | 0 | 2212 | American Decorative Arts 1 | Compote 260 | Compote | German 27 | Maker 1 | Koenigliche Porzellan Manufaktur | German, founded 1763 | 1763 | 9999 | ca. 1844–47 | 1841 | 1847 | Porcelain 109 | H. 3 5/8 in. (9.2 cm); Diam. 5 5/8 in. (14.3 cm) | Bequest of Adeline R. Brown, 1947 | Made in 1 | Berlin 120 | Germany 16 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/2212 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
2037 | 2037 | 46.140.764 | 0 | 1 | 2213 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Mount Washington Glass Company | 1837–1958 | Mount Washington Glass Company 358 | 1837 | 1958 | ca. 1885–87 | 1882 | 1887 | Blown glass 168 | H. 4 5/8 in. (11.7 cm); Diam. 6 1/2 in. (16.5 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | New Bedford 65 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2213 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2038 | 2038 | 46.140.382 | 0 | 1 | 2214 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Richards and Hartley Flint Glass Co. | ca. 1870–1890 | Richards and Hartley Flint Glass Co. 209 | 1867 | 1890 | ca. 1888 | 1885 | 1888 | Pressed colorless and opalescent glass 283 | H. 4 1/2 in. (11.4 cm); Diam. 8 in. (20.3 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Tarentum 55 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2214 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2039 | 2039 | 69.39 | 0 | 1 | 2215 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Designer|Manufacturer|Maker 10 | Designed by|Attributed to | Louis Comfort Tiffany|Tiffany Glass and Decorating Company|Tiffany Studios | American, New York 1848–1933 New York|American, 1892–1902|1902–32 | or | Tiffany, Louis Comfort|Tiffany Glass and Decorating Company|Tiffany Studios 207 | American 1 | 1848 |1892 |1902 | 1933 |1902 |1932 | ca. 1900–1920 | 1897 | 1920 | Favrile glass 231 | H. 5 3/8 in. (13.7 cm); Diam. 9 5/8 in. (24.4 cm) | Purchase, The Edgar J. Kaufmann Foundation Gift, 1969 | Made in 1 | New York 3 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2215 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||
2040 | 2040 | 1984.443.7 | 0 | 1 | 2216 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Union Porcelain Works | 1863–ca. 1922 | Union Porcelain Works 184 | 1863 | 1922 | 1875–90 | 1875 | 1890 | Porcelain 109 | H. 1 15/16 in. (4.9 cm); Diam. 8 7/8 in. (22.5 cm) | Gift of Florence I. Balasny-Barnes, in memory of her sister, Yvette B. Gould, 1984 | Made in 1 | Brooklyn 48 | United States 3 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/2216 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2041 | 2041 | 68.114 | 0 | 1 | 2217 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | William Gale and Son | active ca. 1850–58 and 1863–66 | Gale and Son William 359 | 1847 | 1866 | ca. 1860 | 1857 | 1860 | Silver 2 | Overall: 9 1/2 x 10 7/16 in. (24.1 x 26.5 cm); 40 oz. 1 dwt. (1245.7 g) Lip: Diam. 9 3/8 in. (23.8 cm) Foot: Diam. 6 1/4 in. (15.9 cm) | Purchase, Anonymous Gift, 1968 | Made in 1 | New York 3 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/2217 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2042 | 2042 | Inst.67.15.1 | 0 | 1 | 2218 | American Decorative Arts 1 | Compote 260 | Compote | French 7 | 1815–30 | 1815 | 1830 | Porcelain 109 | 11 3/8 x 14 1/4 x 7 3/8 in. (28.9 x 36.2 x 18.7 cm) | Gift of Mrs. Alan W. Carrick, 1967 | Made in 1 | Paris 27 | France 9 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/2218 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
2043 | 2043 | 69.194.178 | 0 | 1 | 2219 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Union Porcelain Works | 1863–ca. 1922 | Union Porcelain Works 184 | 1863 | 1922 | 1885 | 1885 | 1885 | Porcelain 109 | H. 7 in. (17.8 cm); Diam. 9 1/4 in. (23.5 cm) | Gift of Mr. and Mrs. Franklin Chace, 1969 | Made in 1 | Brooklyn 48 | United States 3 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/2219 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2044 | 2044 | Inst.67.15.2 | 0 | 1 | 2220 | American Decorative Arts 1 | Compote 260 | Compote | French 7 | 1815–30 | 1815 | 1830 | Porcelain 109 | 10 3/8 x 12 5/16 x 6 3/8 in. (26.4 x 31.3 x 16.2 cm) | Gift of Mrs. Alan W. Carrick, 1967 | Made in 1 | Paris 27 | France 9 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/2220 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
2045 | 2045 | Inst.67.15.3 | 0 | 1 | 2221 | American Decorative Arts 1 | Compote 260 | Compote | French 7 | 1815–30 | 1815 | 1830 | Porcelain 109 | 10 3/16 x 12 x 6 5/8 in. (25.9 x 30.5 x 16.8 cm) | Gift of Mrs. Alan W. Carrick, 1967 | Made in 1 | Paris 27 | France 9 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/2221 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
2046 | 2046 | 69.194.177 | 0 | 1 | 2222 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Union Porcelain Works | 1863–ca. 1922 | Union Porcelain Works 184 | 1863 | 1922 | 1885 | 1885 | 1885 | Porcelain 109 | H. 5 3/4 in. (14.6 cm); Diam. 9 7/16 in. (24 cm) | Gift of Mr. and Mrs. Franklin Chace, 1969 | Made in 1 | Brooklyn 48 | United States 3 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/2222 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2047 | 2047 | 69.194.179 | 0 | 1 | 2223 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Union Porcelain Works | 1863–ca. 1922 | Union Porcelain Works 184 | 1863 | 1922 | 1885 | 1885 | 1885 | Porcelain 109 | H. 5 3/4 in. (14.6 cm); Diam. 9 9/16 in. (24.3 cm) | Gift of Mr. and Mrs. Franklin Chace, 1969 | Made in 1 | Brooklyn 48 | United States 3 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/2223 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2048 | 2048 | 46.140.540 | 0 | 1 | 2224 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Adams and Company | Adams and Company 153 | 9999 | 1870–90 | 1870 | 1890 | Pressed glass 5 | H. 5 3/4 in. (14.6 cm); Diam. 8 5/8 in. (21.9 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2224 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
2049 | 2049 | 46.140.541 | 0 | 1 | 2225 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Adams and Company | Adams and Company 153 | 9999 | 1870–90 | 1870 | 1890 | Pressed yellow glass 221 | H. 5 3/4 in. (14.6 cm); Diam. 8 5/8 in. (21.9 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2225 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
2050 | 2050 | 46.140.855 | 0 | 1 | 2226 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Bakewell, Pears and Company | 1836–1882 | Bakewell, Pears and Company 140 | 1836 | 1882 | 1860–80 | 1860 | 1880 | Pressed glass 5 | H. 9 1/8 in. (23.2 cm); Diam. 10 1/2 in. (26.7 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2226 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2051 | 2051 | 46.140.856 | 0 | 1 | 2227 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Bakewell, Pears and Company | 1836–1882 | Bakewell, Pears and Company 140 | 1836 | 1882 | 1860–80 | 1860 | 1880 | Pressed glass 5 | H. 9 1/8 in. (23.2 cm); Diam. 10 1/2 in. (26.7 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2227 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2052 | 2052 | 46.140.853 | 0 | 1 | 2228 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Bryce Brothers | Bryce, Brothers 360 | 9999 | 1876–85 | 1876 | 1885 | Pressed glass 5 | 8 7/8 × 9 7/8 × 6 7/8 in. (22.5 × 25.1 × 17.5 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2228 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
2053 | 2053 | 46.140.854 | 0 | 1 | 2229 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Bryce Brothers | Bryce, Brothers 360 | 9999 | 1876–85 | 1876 | 1885 | Pressed glass 5 | 8 7/8 × 10 3/4 × 7 1/2 in. (22.5 × 27.3 × 19.1 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2229 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
2054 | 2054 | 46.140.637 | 0 | 1 | 2230 | American Decorative Arts 1 | Compote 260 | Purple marble glass compote | American 1 | Maker 1 | Challinor, Taylor and Company | 1866–1891 | Challinor, Taylor and Company 142 | 1866 | 1891 | 1870–90 | 1870 | 1890 | Pressed purple marble glass 122 | H. 7 5/8 in. (19.4 cm); Diam. 8 1/4 in. (21 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Tarentum 55 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2230 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2055 | 2055 | 46.140.638 | 0 | 1 | 2231 | American Decorative Arts 1 | Compote 260 | Purple marble glass compote | American 1 | Maker 1 | Challinor, Taylor and Company | 1866–1891 | Challinor, Taylor and Company 142 | 1866 | 1891 | 1870–90 | 1870 | 1890 | Pressed purple marble glass 122 | H. 7 5/8 in. (19.4 cm); Diam. 8 1/4 in. (21 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Tarentum 55 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2231 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2056 | 2056 | 46.140.542 | 0 | 1 | 2232 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Adams and Company | Adams and Company 153 | 9999 | 1870–90 | 1870 | 1890 | Pressed yellow glass 221 | H. 4 3/4 in. (12.1 cm); Diam. 5 1/2 in. (14 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2232 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
2057 | 2057 | 46.140.543 | 0 | 1 | 2233 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Adams and Company | Adams and Company 153 | 9999 | 1870–90 | 1870 | 1890 | Pressed yellow glass 221 | H. 4 3/4 in. (12.1 cm); Diam. 5 1/2 in. (14 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2233 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
2058 | 2058 | 46.140.544 | 0 | 0 | 2234 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Adams and Company | Adams and Company 153 | 9999 | 1870–90 | 1870 | 1890 | Pressed yellow glass 221 | H. 4 3/4 in. (12.1 cm); Diam. 5 1/2 in. (14 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2234 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
2167 | 2167 | 46.140.825a, b | 0 | 1 | 2349 | American Decorative Arts 1 | Compote 260 | Covered Compote | American 1 | 1850–70 | 1850 | 1870 | Pressed glass 5 | H. 8 1/4 in. (21 cm); Diam. 6 1/8 in. (15.6 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2349 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
2168 | 2168 | 46.140.83a, b | 0 | 1 | 2351 | American Decorative Arts 1 | Compote 260 | Covered compote | American 1 | Maker 1 | Bakewell, Pears and Company | 1836–1882 | Bakewell, Pears and Company 140 | 1836 | 1882 | 1850–70 | 1850 | 1870 | Pressed glass 5 | H. 14 1/8 in. (35.9 cm); Diam. 8 in. (20.3 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Probably made in 2 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/2351 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
2169 | 2169 | 46.140.858a, b | 0 | 1 | 2352 | American Decorative Arts 1 | Compote 260 | Covered compote | American 1 | Maker 1 | James Gillinder and Sons | American, 1861–ca. 1930 | Gillinder and Sons, James 5 | American 1 | 1861 | 1930 | 1880–90 | 1880 | 1890 | Pressed glass 5 | H. 7 1/2 in. (19.1 cm); Diam. 5 in. (12.7 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Possibly made in|Possibly made in 3 | Philadelphia|Greensburg 129 | United States|United States 8 | Glass 3 | http://www.metmuseum.org/art/collection/search/2352 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
4832 | 4832 | 46.140.342 | 0 | 1 | 5189 | American Decorative Arts 1 | Compote 260 | Miniature Compote | American 1 | 1835–55 | 1835 | 1855 | Lacy pressed glass 218 | H. 2 in. (5.1 cm); Diam. 1 15/16 in. (4.9 cm) | Gift of Mrs. Emily Winthrop Miles, 1946 | Made in 1 | United States 3 | New England 1 | Glass 3 | http://www.metmuseum.org/art/collection/search/5189 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
12332 | 12332 | 1990.257 | 0 | 1 | 13457 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Designer|Manufacturer 3 | Designed by|Manufactured by | Charles G. Summers|Canton Glass Company | ca. 1882–1899 | Summers, Charles G.|Canton Glass Company 1953 | 1879 | 9999 |1899 | ca. 1882 | 1879 | 1882 | Glass 31 | H. 11 13/16 in. (30 cm); Diam. 8 5/16 in. (21.1 cm) | Gift of Mr. and Mrs. Thomas R. Trowbridge III, 1990 | Made in 1 | Canton 62 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/13457 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
13139 | 13139 | 1991.30.5 | 0 | 1 | 14287 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | ca. 1845–65 | 1842 | 1865 | Glass 31 | H. 5 3/4 in. (14.6 cm); Diam. 7 3/16 in. (18.3 cm) | Gift of the Estate of Marguerite Raeder Laporte, 1991 | Probably made in 2 | United States 3 | New England 1 | Glass 3 | http://www.metmuseum.org/art/collection/search/14287 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
14408 | 14408 | 1997.65 | 0 | 1 | 15594 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | ca. 1845–75 | 1845 | 1875 | Blown glass with applied decoration 112 | 11 5/8 x 14 1/2 in. (29.5 x 36.8 cm) | Purchase, Dr. and Mrs. Burton P. Fabricand Gift, 1997 | Probably made in 2 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/15594 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
15456 | 15456 | 2000.193 | 0 | 1 | 16738 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Artist 2 | Bakewell, Page & Bakewell | 1808–1882 | Bakewell, Page & Bakewell 267 | 1808 | 1882 | 1820–35 | 1820 | 1835 | Blown and cut glass 219 | Overall: H. 7 1/4 in. (18.4 cm) Rim: Diam. 9 3/16 in. (23.3 cm) Foot: Diam. 4 13/16 in. (12.2 cm) | Gift of Clare Wagner Silka, 2000 | Made in 1 | Pittsburgh 32 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/16738 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
15799 | 15799 | 2002.566 | 0 | 1 | 17220 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | 1835–45 | 1835 | 1845 | Pressed glass 5 | 6 x 9 x 10 3/4 in. (15.2 x 22.9 x 27.3 cm) | Gift of Mr. and Mrs. Robert Keuffel Keller, from the Gretchen Keuffel Keller Collection, 2002 | Probably made in 2 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/17220 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
16662 | 16662 | 2009.344 | 0 | 1 | 20107 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Joseph Stouvenal and Company | 1851–57 | Joseph Stouvenal and Company 356 | 1851 | 1857 | ca. 1851–55 | 1846 | 1856 | cut and engraved glass 3211 | 11 in. (27.9 cm) Body diameter: 12 in. (30.5 cm) | Purchase, Robert L. and Ann R. Fromer Gift, 2009 | (none assigned) 9 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/20107 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
16862 | 16862 | 2013.959.12.2 | 0 | 0 | 20556 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Robert Sturm | 1874–1964 | Sturm, Robert 2613 | 1874 | 1874 | ca. 1910 | 1905 | 1915 | Silver 2 | 5 1/4 × 6 3/8 in. (13.3 × 16.2 cm) | Gift, Silver & Metalwork of the Twentieth Century from the Margo Grant Walsh Collection, 2013 | Made in 1 | Cincinnati 41 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/20556 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
106695 | 106695 | 19.44.3 | 0 | 1 | 194546 | European Sculpture and Decorative Arts 3 | Compote 260 | Compote | German 27 | dated 1792 | 1792 | 1792 | Pewter 104 | Overall: 6 3/8 × 8 3/8 in. (16.2 × 21.3 cm) | Gift of Mrs. John Stemme, 1919 | Metalwork-Pewter 19 | http://www.metmuseum.org/art/collection/search/194546 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||||
109425 | 109425 | 34.160 | 0 | 0 | 197481 | European Sculpture and Decorative Arts 3 | Compote 260 | Compote | French, Sèvres 2212 | Factory 328 | Sèvres Manufactory | French, 1740–present | Sèvres Manufactory 1209 | French 2 | 1740 | 9999 | 19th century | 1800 | 1899 | Hard-paste porcelain 572 | 2 1/2 × 8 1/2 in. (6.4 × 21.6 cm) | Anonymous Gift, in memory of Roswell and Anne Augusta Skeel, 1934 | Ceramics-Porcelain 307 | http://www.metmuseum.org/art/collection/search/197481 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
337433 | 337433 | 1988.191.2 | 0 | 0 | 485005 | Modern and Contemporary Art 4 | Compote 260 | Compote | Designer 5 | Carlo Scarpa | Italian, Venice 1906–1978 Sendai, Japan | Scarpa, Carlo 45843 | Italian 6 | 1906 | 1978 | 1970 | 1970 | 1970 | Sterling silver 15973 | 3 1/2 × 12 3/8 × 12 1/2 in. (8.9 × 31.4 × 31.8 cm) | Gift of Cleto Munari, Vicenza, Italy, 1988 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/485005 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
337438 | 337438 | 1988.191.7 | 0 | 0 | 485010 | Modern and Contemporary Art 4 | Compote 260 | Compote | Designer 5 | Hans Hollein | Austrian, born 1934 | Hollein, Hans 45848 | Austrian 66 | 1934 | 2034 | 1980 | 1980 | 1980 | Silverplate, enamel 51841 | 8 3/8 × 17 3/4 × 17 7/8 in. (21.3 × 45.1 × 45.4 cm) | Gift of Cleto Munari, 1988 | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/485010 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
395264 | 395264 | 2013.959.12.1 | 0 | 0 | 648321 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Maker 1 | Robert Sturm | 1874–1964 | Sturm, Robert 2613 | 1874 | 1874 | ca. 1910 | 1905 | 1915 | Silver 2 | 5 1/4 × 6 3/8 in. (13.3 × 16.2 cm) | Gift, Silver & Metalwork of the Twentieth Century from the Margo Grant Walsh Collection, 2013 | Made in 1 | Cincinnati 41 | United States 3 | Silver 2 | http://www.metmuseum.org/art/collection/search/648321 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
408003 | 408003 | 2014.624 | 0 | 1 | 667455 | American Decorative Arts 1 | Compote 260 | Compote | American 1 | Manufacturer|Manufacturer 19 | Probably|Possibly | New England Glass Company|Cape Cod Glass Works | American, East Cambridge, Massachusetts, 1818–1888|1858–69 | New England Glass Company |Cape Cod Glass Works 51450 | 1818 |1858 | 1888 |1869 | 1855–70 | 1855 | 1870 | Red-cut-to-clear-glass 59335 | 9 1/4 × 10 1/4 in. (23.5 × 26 cm) | Purchase, Anne Cox Chambers Gift, 2014 | Probably made in 2 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/667455 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
449167 | 449167 | L.2017.26.1 | 0 | 0 | 751986 | European Sculpture and Decorative Arts 3 | Compote 260 | Compote | Norwegian, Oslo 2318 | Manufactory|Maker 432 | Firm of | David-Andersen|David Andersen | Norwegian, 1876–present|Norwegian, 1843–1901 | , or | David-Andersen|Andersen, David 57414 | 1876 |1843 | 2099 |1901 | ca. 1900 | 1895 | 1905 | Silver, gold wire, enamel, amethyst, moonstone 62778 | Overall (confirmed): 5 1/16 × 16 5/8 × 11 5/8 in. (12.9 × 42.2 × 29.5 cm) | Metalwork-Silver 313 | http://www.metmuseum.org/art/collection/search/751986 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
CREATE TABLE "MetObjects" ( "Object Number" TEXT, "Is Highlight" INTEGER, "Is Public Domain" INTEGER, "Object ID" INTEGER, "Department" INTEGER, "Object Name" INTEGER, "Title" TEXT, "Culture" INTEGER, "Period" REAL, "Dynasty" INTEGER, "Reign" INTEGER, "Portfolio" INTEGER, "Artist Role" INTEGER, "Artist Prefix" REAL, "Artist Display Name" TEXT, "Artist Display Bio" TEXT, "Artist Suffix" REAL, "Artist Alpha Sort" INTEGER, "Artist Nationality" INTEGER, "Artist Begin Date" TEXT, "Artist End Date" TEXT, "Object Date" TEXT, "Object Begin Date" INTEGER, "Object End Date" INTEGER, "Medium" INTEGER, "Dimensions" TEXT, "Credit Line" TEXT, "Geography Type" INTEGER, "City" INTEGER, "State" INTEGER, "County" INTEGER, "Country" INTEGER, "Region" INTEGER, "Subregion" INTEGER, "Locale" INTEGER, "Locus" INTEGER, "Excavation" INTEGER, "River" INTEGER, "Classification" INTEGER, "Rights and Reproduction" REAL, "Link Resource" TEXT, "Metadata Date" TEXT, "Repository" INTEGER , FOREIGN KEY ("Department") REFERENCES [Department](id), FOREIGN KEY ("Object Name") REFERENCES [Object Name](id), FOREIGN KEY ("Culture") REFERENCES [Culture](id), FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id), FOREIGN KEY ("Reign") REFERENCES [Reign](id), FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id), FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id), FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id), FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id), FOREIGN KEY ("Medium") REFERENCES [Medium](id), FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id), FOREIGN KEY ("City") REFERENCES [City](id), FOREIGN KEY ("State") REFERENCES [State](id), FOREIGN KEY ("County") REFERENCES [County](id), FOREIGN KEY ("Country") REFERENCES [Country](id), FOREIGN KEY ("Region") REFERENCES [Region](id), FOREIGN KEY ("Subregion") REFERENCES [Subregion](id), FOREIGN KEY ("Locale") REFERENCES [Locale](id), FOREIGN KEY ("Locus") REFERENCES [Locus](id), FOREIGN KEY ("Excavation") REFERENCES [Excavation](id), FOREIGN KEY ("River") REFERENCES [River](id), FOREIGN KEY ("Classification") REFERENCES [Classification](id), FOREIGN KEY ("Repository") REFERENCES [Repository](id)); CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department"); CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name"); CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture"); CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty"); CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign"); CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio"); CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role"); CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort"); CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality"); CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium"); CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type"); CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City"); CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State"); CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County"); CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country"); CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region"); CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion"); CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale"); CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus"); CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation"); CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River"); CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification"); CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository"); CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight"); CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain"); CREATE INDEX metobjects_Department ON MetObjects("Department"); CREATE INDEX metobjects_Culture ON MetObjects("Culture"); CREATE INDEX metobjects_Period ON MetObjects("Period"); CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty"); CREATE INDEX metobjects_Medium ON MetObjects("Medium"); CREATE INDEX metobjects_City ON MetObjects("City"); CREATE INDEX metobjects_State ON MetObjects("State"); CREATE INDEX metobjects_County ON MetObjects("County"); CREATE INDEX metobjects_Country ON MetObjects("Country"); CREATE INDEX metobjects_Region ON MetObjects("Region"); CREATE INDEX metobjects_Subregion ON MetObjects("Subregion"); CREATE INDEX metobjects_Locale ON MetObjects("Locale"); CREATE INDEX metobjects_Locus ON MetObjects("Locus"); CREATE INDEX metobjects_Excavation ON MetObjects("Excavation"); CREATE INDEX metobjects_River ON MetObjects("River");